AcademicAdvisor 
EntityType  Independent 
Logical Entity Name  AcademicAdvisor 
Default Table Name  AdAdvisor 
Logical Only  YES 
Definition 
CREATE VIEW dbo.AdAdvisorASSELECT     syStaff.code,     systaff.sycampusgrpid,     systaff.lastname,         systaff.firstname,     systaff.addr1,     systaff.addr2,     systaff.city,         systaff.state,     systaff.zip,     systaff.phone,     systaff.active,         systaff.userid,     systaff.dateadded,     systaff.datelstmod,         systaff.descrip,     syStaff.syStaffID AS AdAdvisorIDFROM syStaffByGroup (nolock)LEFT OUTER JOIN syStaff (nolock)   ON syStaff.syStaffID = syStaffByGroup.syStaffID LEFT OUTER JOIN syStaffGroup (nolock)   ON syStaffGroup.syStaffGroupID = syStaffByGroup.syStaffGroupIDWHERE syStaffGroup.code = 'ACAD'
 
Note 
 

AcademicAdvisor Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 

AcademicAdvisor Keys 
Key Name  Key Type  Keys 

AcademicAdvisor Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

AcademicAdvisor Check Constraints 
Check Constraint Name  CheckConstraint